2016-04-25 - 26775 - Spec - GLPCA hierarchy removal #BExQueriesforCrystalReportsAnalysisTool
Specification
26775 - GLPCA hierarchy removal
Purpose
Need to remove the node, sub node hierarchy in the GLPCA analysis for OLAP and show them as characteristics.
Admin Info
Purpose
|
Need to remove the hierarchy in the GLPCA analysis for OLAP and show them as characteristics.
|
Requested By
|
John Thompson
|
Spec Created By
|
Naveen Gadde
|
Spec Created Date
|
04/26/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
VMP_GLPC_Q002
|
Document Status
|
Complete
|
Estimates
SlNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
01
|
2
|
Documentation
|
01
|
3
|
Development/ Config
|
03
|
4
|
Unit test in DEV
|
01
|
5
|
Unit test in QUA
|
00
|
6
|
Other activity
|
02
|
|
TOTAL
|
08
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to create a new BEx Query same as VMP_GLPC_Q001 and change the 0GL_ACCOUNT hierarchy property to 0GL_ACCOUNT characteristic.
In Scope:
None
Out of Scope:
None
Solution Summary
1. Need to create a new BEx Query same as VMP_GLPC_Q001.
2. Need to change the 0GL_ACCOUNT Hierarchy to 0GL_ACCOUNT characteristic.
2. Need to validate the changes in BPD.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Need to check if the 0GL_ACCOUNT hierarchy is replaced by characteristic in the BEx Query.
|
0GL_ACCOUNT hierarchy is replaced by characteristic in the BEx Query.
|
2
|
All the changes should be collected into the transport request.
|
All the changes collected into the transport request successfully.
|
Solution Details
1. Need to create a new BEx Query VMP_GLPC_Q002 same as VMP_GLPC_Q001.
2. Need to change the 0GL_ACCOUNT Hierarchy to 0GL_ACCOUNT characteristic.
2. Need to validate the changes in BPD & BPQ.
Issues
None